﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SelectClassHeader.aspx.cs" Inherits="TeacherEval_School_ScoreInput_SelectClassHeader" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>
<%------班主任
--select TEACHERINFO.* from TEACHERINFO
--inner join CLSINFO on CLSINFO.HEADERID = TEACHERINFO.rid
--where TEACHERINFO.ISEFFECT = 1 and CLSINFO.ISEFFECT = 1 and 
--TEACHERINFO.SCHOOLMARK='School' and Grade = 7
--order by CLSINFO.CLSNO asc

-----任课教师
--select distinct TEACHERINFO.* from TEACHERINFO
--inner join TEACHCLSCAUSE on TEACHCLSCAUSE.TEACHID = TEACHERINFO.rid
--where TEACHERINFO.ISEFFECT=1 and TEACHCLSCAUSE.CAUSEID=1

----行政人员 4  教学辅助  5 
--select distinct TEACHERINFO.* from TEACHERINFO
--inner join TeacherRoles on TeacherRoles.TeacherID  = TEACHERINFO.rid
--where TEACHERINFO.ISEFFECT=1 and  RoleID=4
--%>
